package info.cuatrvientos.org;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Servlet implementation class Home
 * @author pablo_guerrero
 */
@WebServlet("/Home")
public class Home extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public Home() {
        super();
        // TODO Auto-generated constructor stub
    }

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		redirectHome(request, response);
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		redirectHome(request, response);
	}
	
	 private void redirectHome(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
         String tales = getTales();
         request.setAttribute("tales",tales);
         this.getServletContext().getRequestDispatcher("/home.jsp").forward(request,response);
 }
 
 /**
  * return the list of tales from de DB
  * @return string allTales
  */
 private String getTales(){
         String allTales="";
         
         String urlcon = "jdbc:mysql://localhost:3306/onceupon";
         ResultSet resultSet = null;
         Connection conn;
         try {
                 Class.forName("com.mysql.jdbc.Driver");
                 conn = DriverManager.getConnection(urlcon,"root","");
                 Statement stat = conn.createStatement();
                 resultSet = stat.executeQuery("Select * from tale");
                 
                 while(resultSet.next()){
                         allTales += resultSet.getString("title") + "  -  "+ "<a href='Delete?id="+resultSet.getString("id")+"'title='delete'>delete</a>" + "  -  "+ "<a href='Update?id="+resultSet.getString("id")+"'title='update'>update</a>" + "<br />";
                 }
         } catch (SQLException e) {
                 // TODO Auto-generated catch blockx
                 e.printStackTrace();
         } catch (ClassNotFoundException e) {
                 // TODO Auto-generated catch block
                 e.printStackTrace();
         }       
         return allTales;
 }

}
